package com.eascs.web.o2o.web.aging.service.impl;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.eascs.web.o2o.web.aging.service.SysOrgDao;
import com.eascs.web.o2o.web.dao.BiodsDao;
import com.eascs.workflow.common.entity.sys.ActOrgEntity;

@Repository
public class SysOrgDaoImpl extends BiodsDao implements SysOrgDao {
	private static final String ACT_ORG_TABLE = "ods_o2oworkflow_act_org";
	@Override
	public List<ActOrgEntity> getOrgProvince() {
		String sql = " SELECT * FROM "+ACT_ORG_TABLE+" org WHERE org.level=2 AND (org.is_natural_province IS NULL OR org.is_natural_province= 1)";
		return super.findEntitys(sql, ActOrgEntity.class);
	}
}
